from django.db import models
from datetime import datetime
from django.utils import timezone



#无限极分类
class Cate(models.Model):

	#分类名称
	name = models.CharField(max_length=500)
	#父id
	pid = models.IntegerField()

	class Meta:
		db_table = 'cate'



#基类
class Base(models.Model):

	#创建事件
	create_time = models.DateTimeField(default=timezone.now,null=True)

	class Meta:
		abstract = True


# 建立商品表
class KaoGoods(Base):
	# 商品名称
	name = models.CharField(max_length=200)
	

# 关注表
class UserFlow(Base):

	# 谁关注的
	uid = models.IntegerField()
	# 关注的那个商品
	gid = models.IntegerField()

	class Meta:
		db_table = "userflow"


# 用户评论
class Comment(Base):
	# 内容
	content = models.CharField(max_length=200)
	# 谁评论的
	uid = models.IntegerField()
	# 评论的那个商品
	gid = models.IntegerField()

	class Meta:
		db_table = 'comment'


# 建立商品表
class Goods(Base):
	# 商品名称
	name = models.CharField(max_length=200)
	# 商品简介
	desc = models.CharField(max_length=500)
	# 商品规格
	parms = models.CharField(max_length=500)
	# 商品头图
	img = models.CharField(max_length=200,null=True)
	# 演示视频
	video = models.CharField(max_length=200,null=True)
	# 价格
	price = models.IntegerField()
	# 关注数
	flow = models.IntegerField(default=0,null=True)
	# 分类id
	cate_id = models.IntegerField()

	class Meta:
		db_table = "goods"


#用户类
class User(Base):

	#用户名
	username = models.CharField(max_length=200)
	#密码
	password = models.CharField(max_length=200)
	#头像
	img = models.CharField(max_length=200)
	#类别  0普通用户 1超级管理员
	type = models.IntegerField(default=0,null=True)

	#声明表名
	class Meta:
		db_table = "user"


# 幻灯片
class Pics(Base):
	# 名称
	title = models.CharField(max_length=200)
	# 超链接
	link = models.CharField(max_length=200)
	# 图片
	img = models.CharField(max_length=200)

	class Meta:
		db_table = "pics"

